SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures
WHERE kategorija = 'BY City oprema'
ORDER BY cena LIMIT 9,9
BY CITY Route II jeans ženske hlače modre
104,90 €
BY CITY Route II jeans ženske hlače črne
104,90 €
BY CITY Route II jeans ženske hlače t.modre
104,90 €
BY CITY Summer Route jakna črna
119,90 €
BY CITY Summer Route jakna krem
119,90 €
BY CITY Summer Route ženska jakna krem
119,90 €
BY CITY Summer Route ženska jakna črna
119,90 €
BY CITY Jogger hlače
149,90 €
BY CITY Mixed III hlače krem
149,90 €